﻿IF Not EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SPIDX]') AND type in (N'U'))
CREATE TABLE [dbo].[SPIDX](
	[Name] [nvarchar](50) NOT NULL,
	[Type] [nvarchar](50) NULL,
	[Description] [nvarchar](255) NULL,
	[Dimensions] [tinyint] NULL,
	[Table] [nvarchar](255) NULL,
	[PrimaryKeyColumn] [nvarchar](255) NULL,
	[IndexColumn] [nvarchar](255) NULL,
	[DataColumn] [ntext] NULL,
	[DataColumnNames] [ntext] NULL,
	[Options] [ntext] NULL,
	[min] [varbinary](max) NULL,
	[max] [varbinary](max) NULL,
	[mean] [varbinary](1) NULL,
	[covarianceMatrix] [varbinary](1) NULL,
	[whiteningMatrix] [varbinary](1) NULL
) 